package com.iss.airsys.dao;

import com.iss.airsys.entity.Employee;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import org.apache.ibatis.annotations.Update;
import org.springframework.stereotype.Repository;

import java.util.List;

@Mapper
@Repository
public interface EmployeeDao {
    @Select("select * from employee")
    public List<Employee> selctAll();
    @Update("update employee set em_picture=#{em_picture} where em_id=#{em_id}")
    Integer updateInfo(@Param("em_picture") String em_picture, @Param("em_id") Integer em_id);
    @Select("select em_picture from employee where em_id=#{em_id}")
    String selectpicture(Integer em_id);
}
